/****** Object:  Stored Procedure AdjustQuantityGetList    Script Date: Wednesday, October 24, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spAdjustQuantityGetListByBulkOrder]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spAdjustQuantityGetListByBulkOrder]
GO

	
	
CREATE PROCEDURE spAdjustQuantityGetListByBulkOrder	
	@BulkOrderID int	
AS


SELECT
	[AdjustQuantity].[AdjustQuantityID],
	[Amount],
	[AdjustedDate],
	[Comment],
	[BulkOrderID],
	[AdjustedByUserID],
	[POID]
FROM
	 [AdjustQuantity]
WHERE BulkOrderID = @BulkOrderID
ORDER BY [AdjustedDate]

GO

	
